SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 158438 LIMIT 1 [ RunTime:0.001099s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 158438 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575960,170429,110730,812920,964900,938435,230629,771996,575686,322184,60865,264575,515063,439099,877463,803623,776288,803350,535207,48140,152575,489047,975936,748867,418275,478220,398294,250332,677794,233644,948506,216135,906844,343731,486282,438345,648880,204603,569739,158475,383089,480774,656800,774005,114251,825503,902932,619672,985682,791993,186646,249663,180555,565016,395669,149784,175658,922358,124772,389542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 158438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 158438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003111s ]