SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044402 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044402 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866711,165192,172292,88089,687209,112064,606031,243036,178494,433894,696805,399510,683007,50253,88605,260852,570986,356593,513769,124245,138059,475537,161335,740276,293617,322702,157843,696226,227704,887731,603004,959634,870554,663701,926765,487541,360954,256246,105870,884719,414817,403998,217678,516775,720061,275412,266042,107219,665571,1008750,807342,671318,882042,323432,665674,245364,1021443,685363,152691,923065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]