SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429334 LIMIT 1 [ RunTime:0.001010s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429334 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117553,399086,49115,638211,496827,368104,578941,515299,971670,344048,225638,944013,458635,148056,49919,236125,929861,263238,852305,392289,496013,194173,400274,855743,456556,387156,274940,934358,731485,109648,38122,413506,472830,50267,158014,561071,668138,316421,137325,44477,370312,214893,826785,1046583,714349,1003312,1033420,617275,658089,350348,829560,672404,364112,643922,264066,40782,348715,217264,245506,357063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001449s ]