SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412121 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412121 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56318,830837,721839,457411,405104,11248,696610,573692,52520,597534,872234,996364,411247,530812,627323,311711,716117,470657,149073,889697,296357,959309,260616,454582,621410,999989,456332,573166,924686,405787,309263,889717,663213,303247,399435,989077,44073,444663,421130,559143,239872,90016,1045799,593932,814270,83616,250239,821221,589160,938763,22277,841874,669078,319098,896307,584792,555873,514472,861972,483136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]