SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150353 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150353 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422526,1046055,574007,1031143,296214,298240,215632,335515,771189,822170,575859,368739,326789,86625,231916,834864,2528,881477,888612,613545,604075,161505,613023,108322,472967,675197,308403,401709,390672,389554,979794,370218,587712,417884,490681,306750,152623,176154,316019,21541,82429,393981,964012,498764,623291,70957,190384,310849,483414,30461,885835,186636,711453,664976,21733,435996,607249,305817,465816,292769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150353 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150353 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]