SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587711 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587711 [ RunTime:0.002728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (16461,252499,621796,977212,692430,928679,808576,641690,717218,1044604,1007513,894032,323314,251247,632224,704564,1009717,93610,743651,178434,96847,544497,452495,516431,112958,416283,671538,584966,306800,875,958726,937522,302660,175714,387240,877796,390695,552030,154266,762168,954619,462402,554604,547402,637430,876632,1006617,855264,718942,534602,401137,186873,19689,71482,15096,234752,180147,933902,688344,385955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]