SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048022 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048022 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426288,700837,929968,948701,436284,828781,318047,554418,542866,991278,401231,973944,769680,354218,264655,399040,503317,227297,164661,675196,139057,338983,843873,217298,861720,680206,254205,578912,302026,345730,540366,565851,928460,820939,64005,29059,432881,586691,105576,943199,896805,900254,358790,171773,541294,595244,814468,551477,162292,467345,316773,1043342,430779,513506,1033855,39898,981458,285106,892551,844537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]