SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404331 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404331 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492946,1026471,460900,276275,516097,298558,358315,144410,162505,115084,404506,308537,394931,303958,348998,817302,593625,737472,93972,746088,426436,99712,638387,1038977,832740,935117,415567,605752,864316,878971,153377,609565,395501,821458,913110,210284,853095,878024,188510,213549,713130,677618,328287,248455,28025,404281,708168,341054,169165,1027512,408616,453420,8782,639277,749358,707023,408045,474921,81760,426279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]