SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040842 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040842 [ RunTime:0.002396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898632,568718,142798,514920,228918,583200,398172,149740,882968,844668,576301,684046,19611,948542,652935,940301,452034,82707,927863,677474,944460,394889,939486,547143,312725,893858,140422,635015,680951,120204,809886,10098,832853,36769,165005,549975,136635,957684,437816,633471,568085,405885,375,1042880,1042463,196153,601908,274387,916846,422012,289238,717990,1023974,401824,549809,183140,711322,11864,375257,991014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]