SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400134 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400134 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771007,589871,227867,89109,780351,723176,148108,659868,729845,287853,168094,845351,979619,769768,722300,447006,672919,787074,76064,153495,616894,48910,377795,507680,306756,810230,115355,798148,474716,17662,106087,257642,419552,49008,200360,898761,643730,946779,435036,780147,331602,609695,186141,228149,1044959,45843,846591,53989,56704,543091,440114,11177,330950,752578,654882,699708,453612,765314,130187,152047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]