SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025805 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025805 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702048,799800,486675,216827,1024314,659869,379711,43959,671050,285919,350414,975867,812153,874036,319114,250331,9596,644852,569173,802106,246508,911147,168540,899694,531657,658189,630401,279370,628717,209703,459947,556886,999108,48865,865467,411443,277427,497133,1004014,612335,675865,92293,289700,530370,553670,892301,400593,556962,747356,15670,221103,572002,161438,318846,502634,1008264,813010,633580,974467,938239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003365s ]