SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200982 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200982 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324414,584143,26492,575475,439894,782607,82281,944875,924421,795237,1020689,982058,751864,911612,987374,929725,481936,539207,282138,901241,818287,685531,909945,34459,891406,69308,355862,685393,310702,142730,703623,338686,746854,300967,140650,355252,951704,409358,960683,216054,146687,437207,465317,411363,212520,264925,389213,691723,407671,961052,933944,124287,791258,459176,562565,196629,947719,651639,394248,24629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200982 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200982 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]