SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549013 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549013 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210229,800400,1044583,959051,298554,948593,425337,547270,187524,381322,9609,440420,799680,179456,308135,769927,913145,428238,288189,603873,241280,260485,314650,410722,9106,56781,952493,882926,942765,813699,127305,305964,500982,466026,144920,571441,154039,622015,718072,485255,1013790,561893,19347,324623,474242,169098,439188,1010637,70404,847408,758710,487487,983190,625582,702609,667925,977415,996535,886742,986554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]