SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 674512 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 674512 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529046,1033142,108929,987955,27418,269072,754242,794204,510679,51451,648604,852267,338127,214258,540090,119975,254298,453720,672973,873179,715706,429402,103000,82083,991445,952392,797371,616874,973855,831594,781051,297037,496340,302410,749305,828591,537391,903201,268489,782170,476810,587321,522664,943282,956028,702912,899175,630613,470380,283397,824797,1005326,945070,996760,364697,402911,498344,464027,329714,966033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 674512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 674512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]