SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417010 LIMIT 1 [ RunTime:0.004635s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417010 [ RunTime:0.009368s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391629,176027,438918,810815,985301,696976,12056,425123,289095,213572,711541,971205,447944,1021172,618880,621747,690321,627861,393004,971988,796294,152184,397101,913389,460355,319849,481822,326862,212803,176260,285358,975058,29259,908356,353464,341691,853598,885210,445552,924955,298785,509790,13645,138382,192818,782109,387060,236954,668847,80369,923057,152623,1041696,579116,13510,995492,809211,752593,550023,1009197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]