SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045314 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045314 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868889,739008,915083,664469,51425,973793,866030,772722,751707,840432,662412,169987,609266,226152,329209,1043120,423956,285571,980041,946593,816341,150749,635116,24912,894709,485650,741102,510084,784456,478778,814927,507316,424684,131844,5115,681012,635902,248080,509380,642604,490597,824493,1044599,711416,52546,769481,63710,424408,638528,266376,39556,57684,315826,762933,60911,32809,41797,440744,460468,157663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]