SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 662300 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 662300 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487671,375551,338722,781540,283722,177169,243548,299615,229849,956639,630545,601949,516291,661074,473635,679913,996729,806841,173105,992649,603699,786195,504746,374280,332237,254373,37684,598378,471892,692677,755583,199395,269562,869853,67513,514453,1021988,519503,545083,508012,479170,461650,891752,914146,200623,1010216,488378,163941,752532,538055,256941,841739,380079,87134,215019,237917,91890,80322,452036,61925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 662300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 662300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]