SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910100 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910100 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452104,180245,836741,826185,972900,769215,333341,238989,829694,116707,378493,375455,400530,749059,964039,141681,708662,750999,72111,958110,451305,162105,349371,775868,1043480,884273,418492,827961,979257,1025037,131334,1042373,941645,653201,976518,1024506,337014,550178,352130,223690,770301,788340,383132,20638,657442,768143,241210,582340,185736,268053,699999,971922,314990,29279,719134,175831,806999,899154,566010,82385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001636s ]