SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532980 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532980 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545337,1041726,943997,286053,175239,1034914,547365,162726,558915,1033993,549485,507068,569062,528289,612898,902094,105029,172921,493769,953043,254530,293838,26236,283065,919224,713347,391939,958310,927237,185899,328815,562177,804926,261138,628030,555508,885835,936676,814968,489287,949854,274587,269702,227272,2753,500422,1005045,438102,69376,801673,428131,816023,512087,459048,33692,611644,405083,580852,58308,640807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]