SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283308 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283308 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644258,109271,264329,140605,471361,1038129,336003,655726,413662,272150,560108,269294,609974,176800,87421,723078,798351,483416,332115,118383,768756,73338,185082,247381,51968,452992,262042,918809,708833,1035133,469548,277912,147404,25941,788272,196406,186796,33538,893963,1029031,885278,545250,762944,153349,599072,433760,794297,722243,285593,780506,90919,764715,890191,1035952,18549,72969,1041205,771466,121217,240890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]