SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584011 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584011 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337548,579562,253509,308175,166031,250018,357305,703813,294316,325981,570565,1046343,312745,223302,733106,805791,348613,98989,1031864,85157,662227,791343,632069,397797,498214,458329,661301,223612,634551,649139,696196,266345,787694,771778,95963,579901,991184,155236,724925,316914,818239,208149,434494,602950,1028367,299908,78697,896515,760407,822081,754686,316049,446562,79959,421751,339043,161768,761497,11072,861677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]