SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104891 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104891 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194249,25555,488865,154139,450940,486463,220297,25633,254114,719006,279438,802621,975879,900724,409415,10741,817728,56671,491367,663401,524813,377556,932201,741986,66021,832559,528189,690701,1011182,1005282,812981,764990,248117,1002073,85490,536277,1007703,684801,826288,45884,103948,637732,381898,672775,461732,643784,568556,840231,56393,416120,778299,335085,703491,812342,794488,650614,156155,489721,107738,431320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]