SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475072 LIMIT 1 [ RunTime:0.009066s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475072 [ RunTime:0.008921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455756,683523,172523,1047552,664323,498826,740600,992996,51680,147434,1005214,762573,796110,556478,946277,495587,40938,829381,719299,428194,544503,47418,279328,730091,449657,529581,956802,366651,934470,152323,85787,639064,627950,250740,94990,24388,25272,938746,1007375,705625,548475,550015,359904,6530,634618,739139,345370,257859,392176,451938,141240,143730,1021124,335744,838281,903952,7175,436811,451705,25144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]