SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584460 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584460 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601096,683874,955097,410126,799913,77473,360034,651704,127211,993119,400955,253343,612544,104851,539220,144752,486997,402762,1047237,424796,169366,669714,858592,487510,676508,394403,687281,35293,303786,254729,958300,672947,316310,230714,477209,716756,313768,571597,674601,598327,816925,500176,376758,187564,834277,69089,727652,998293,984239,391339,660470,414412,631839,649903,875513,680398,337442,1142,243013,450715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001209s ]