SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598797 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598797 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24517,776017,209776,150305,157955,252872,413624,821994,259190,726150,606016,158038,345592,928496,421650,160083,532179,872245,122262,367412,647651,704045,427313,553890,552078,616338,987287,709404,673735,140116,253931,165962,101744,759207,484039,230202,195406,582810,961032,63583,134868,634805,114096,833236,1028326,825411,8641,996573,914959,762038,689008,1042071,893770,683525,1013285,283349,944619,898869,130568,667684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001026s ]