SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545457 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545457 [ RunTime:0.002414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744509,886413,183826,1044518,19155,471548,454221,503238,629370,635594,716964,230126,222397,552109,198982,696448,178535,519638,297908,185935,502877,142847,1009103,784912,178247,285242,190649,550537,367921,880230,78109,979124,865471,672585,700516,136558,225327,560570,213341,396021,249169,847472,979227,139585,109510,999420,1044365,690245,72692,399615,922929,568297,924282,8951,530889,569976,701203,104507,431884,94555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]