SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400296 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400296 [ RunTime:0.002382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181097,116682,534139,404158,458835,445112,449597,995196,853281,772526,544565,705196,565236,420529,789822,248134,887783,406876,249070,867212,239486,175985,825430,50751,512846,74770,62829,945974,1031052,592968,218510,1017616,332940,426565,402770,696791,225199,975618,587696,92425,113620,1006568,693557,968918,124068,175445,711580,500026,728443,327251,336141,910248,636081,682714,407681,199624,780785,449609,719089,269569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400296 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400296 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]