SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41234 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41234 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28759,258334,470340,199243,58749,514233,104767,904402,452725,697186,205753,984544,712614,649476,1027892,963185,474946,462310,297463,462182,485637,211751,931430,598030,938036,866497,922,890957,855334,83093,861737,988458,247871,519653,275915,870501,170400,331479,182278,182185,854415,112580,562394,807369,827103,486246,6719,224444,109771,671011,584668,683067,871783,975929,10602,601972,573060,229278,678081,890302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]