SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300513 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300513 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215152,272628,722897,64710,875807,418339,663829,130538,594561,706422,117515,42977,705811,571998,636176,119029,249754,143554,276915,797082,74808,681793,841835,749348,530090,621958,992482,45592,710012,983561,365688,691062,928573,864517,269406,331123,629796,496427,45671,75196,784810,734749,734882,747065,697451,919440,1027854,261271,724447,923132,444831,241639,232726,195747,510232,654746,390793,1036749,153246,928577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]