SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33158 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33158 [ RunTime:0.003286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018116,1006956,26695,801265,852085,282522,19263,161412,654807,837045,102532,401887,1002814,483606,83047,288236,782666,893131,383191,157175,420485,115204,215727,618414,523232,857849,13088,914030,837080,612106,1020511,1004444,593504,205453,432236,399327,1039723,886034,235929,74788,97836,412836,374595,477050,216760,985486,724114,1035320,261846,300393,527400,308424,536902,785659,428516,666255,458391,366629,553617,893545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]