SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704548 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704548 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346870,661836,740482,33827,842149,330266,1042776,40059,1047298,687475,342573,855008,748856,1002623,401044,49528,123522,945912,79560,609347,23870,39248,830302,270930,715781,968424,417345,751142,308979,822102,521708,220123,782333,284036,59990,1003544,575745,1039142,875665,936252,741835,924549,977829,98384,440177,719811,1018239,39427,907209,460654,204082,469634,361957,908479,86472,412276,138019,718493,107571,1004231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]