SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433984 LIMIT 1 [ RunTime:0.003179s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433984 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506652,652253,440817,618067,296129,1008478,301155,645706,565003,40949,906237,476878,126717,902745,1020627,1032366,569001,201447,846180,688082,706413,992404,11902,741359,708356,26955,303658,110012,134751,947271,236966,259868,510098,1009416,614698,205445,328851,648430,377177,564435,217913,305375,500535,538677,4189,12115,361473,158172,524505,855763,691016,1000304,863037,706644,612023,930608,558618,253207,29766,651545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]