SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40242 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40242 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493810,383668,1010052,1316,1008584,1001305,859842,331151,800803,946030,192443,144800,558305,938252,560745,405191,87977,1048847,930190,78371,926161,867615,467505,570884,137222,206530,644001,777459,444311,993278,683139,429412,697042,104862,166383,580262,19393,551091,406545,395523,508224,621172,164569,121884,599900,105413,471320,961418,105477,498840,281310,996801,910724,700843,180373,227583,388581,1027150,660521,562810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40242 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40242 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]