SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508968 LIMIT 1 [ RunTime:0.000937s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508968 [ RunTime:0.004822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259796,242859,72435,413247,273040,740244,451498,447282,270607,894020,92433,51740,9640,1009355,497849,594271,567891,194576,921742,875140,986154,120944,616950,270045,273360,59192,47531,621491,270477,896077,2709,534311,248422,156096,273570,934745,11701,1013383,740464,647185,77227,117660,15734,218391,270101,709639,567063,153274,348814,615565,653671,167922,744371,393756,877116,473926,357781,526394,855531,822434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]