SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020560 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020560 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526914,905469,480886,533994,689817,59089,1039748,469646,818783,196450,613036,403546,707934,27788,621123,93011,780281,552809,422490,833937,90702,864393,973712,646558,864396,68839,791978,44195,252635,680841,907165,680497,824233,659608,537791,5183,374192,457991,517562,716757,840808,872247,533351,70400,769575,18548,854700,112614,996562,227090,364663,564602,557353,410202,775170,977225,489764,249682,490621,616488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]