SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576731 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576731 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240728,483081,991368,573973,725903,872310,582524,400045,541131,974740,770485,381130,357853,619801,711597,660340,234721,560125,454657,934492,166217,831552,237618,987777,484507,1007117,207539,328020,27657,419245,613314,546414,581584,207748,246932,740912,659786,709891,747943,552709,2778,163462,778970,291811,588893,918240,530943,548676,823924,374673,673143,825319,819171,835623,701737,94136,303163,44940,611532,264429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001709s ]