SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418727 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418727 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158186,538080,220445,720961,983084,748311,481867,139053,781761,883840,694398,142767,129892,348832,832816,839503,213984,525824,964483,868529,780720,172655,83478,602405,904319,216056,490867,189048,613978,588833,803594,1020241,172651,41595,418183,265054,522262,16529,12676,240408,567937,154015,459145,994391,79490,223539,979288,82093,604760,312029,505621,537451,432798,1025184,168375,812192,148399,538317,171697,806878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418727 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418727 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001734s ]