SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51104 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51104 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235619,82779,809107,536939,433619,440017,598260,968863,288643,365659,585129,305607,587395,191908,657984,1019456,437595,977860,867798,952731,20599,494059,120347,302122,194743,114908,549635,792115,649120,611604,148249,20740,89356,697274,745022,1031298,494652,75245,849632,686626,401290,984990,309267,894614,851525,678010,274510,767475,225661,255121,26992,933041,873566,403732,778781,137933,745746,623442,51873,879904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]