SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585280 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585280 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705394,532127,703352,264033,518454,176031,545144,1018310,1015002,431574,248334,452263,852074,995207,763074,496802,149950,276884,684391,936816,577730,511045,968105,211710,501276,390547,650028,238380,557855,415579,487880,213943,751247,398522,121762,699376,955174,381115,44197,988437,310104,760407,693835,509503,272295,797095,865548,836056,990114,933619,536264,547599,325256,450554,18040,415260,694547,828025,558711,814928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]