SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370601 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370601 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701612,86172,1029316,321978,152458,283056,909227,77940,800316,814901,432673,388928,55864,225260,191479,522520,57810,65476,1039818,325605,876006,446896,362575,558739,24823,63726,790043,72349,1002576,673303,952258,1001565,501192,420196,700735,29954,661034,230559,19620,808807,362024,116024,70796,978241,747088,321503,399727,198061,34386,271012,1261,621531,199954,413360,680381,315293,828545,1024557,153987,281167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000993s ]