SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495630 LIMIT 1 [ RunTime:0.000838s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495630 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401734,232863,443154,986798,834612,908703,189776,371170,837738,502468,137018,893956,268908,356633,580868,603943,350945,985546,310453,763128,221509,301281,954568,955422,543282,425843,322218,490500,513405,885349,238151,938189,146271,400109,949883,325449,8582,95565,68643,593391,782680,807240,17763,433211,574811,362995,192047,121747,352007,568731,224887,396496,733046,794568,432123,448618,930444,299697,622819,426793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000873s ]