SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475656 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475656 [ RunTime:0.003018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29395,708139,46,380591,753766,313485,947854,218821,981808,202979,198845,656479,594792,565626,419623,438873,996632,559705,64229,402796,731686,943019,946867,365288,381686,740685,212175,584211,204410,892619,620844,827356,579834,646318,725113,692830,952775,353487,247158,10543,742088,227970,98044,790227,512654,398342,972766,612568,986303,595370,422126,785936,114839,15972,204647,244839,432906,263642,316810,60275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]