SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514254 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514254 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136520,774676,824640,905756,222685,1027230,895076,565955,116127,896279,348935,908958,322259,755367,58355,519198,731686,222753,643288,846968,754804,123625,1028769,358711,556861,144447,640614,514242,759499,186641,145881,1034790,788289,293070,859574,8283,233575,956990,30436,750304,429110,467134,291938,558077,1004134,298221,298675,225145,636397,881301,717153,292749,292458,410420,152826,113249,553066,69582,782593,907830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]