SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002454s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342820 LIMIT 1 [ RunTime:0.001126s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342820 [ RunTime:0.008378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703973,247380,467062,506924,345340,367791,607034,79738,694263,135192,289197,881632,412368,193825,986354,1015398,744858,435525,238009,211506,327849,864439,168960,648495,591682,140807,875897,502725,121514,864192,19597,938292,43052,785354,1018060,507636,487944,335631,180320,661673,731402,877138,531768,184536,207960,137708,515734,264497,678548,101249,389393,547333,202726,472330,914337,932711,99981,341288,310093,984814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]