SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002602s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 90401 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 90401 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522240,299813,732441,209120,273021,555874,986633,727131,850438,29746,795538,435795,623411,183070,150867,805601,2125,628034,926859,542303,75540,314999,888855,713460,330744,977366,214046,141216,953363,7911,362628,520033,411060,778650,775565,941420,52344,524660,369198,310703,227749,644257,136838,52295,876146,707576,587650,422627,700707,355429,486155,923119,593472,901602,814306,159447,1005085,319553,639244,221553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 90401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 90401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]