SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451104 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451104 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474288,918418,10323,957043,652405,40953,503274,469098,16870,91741,649912,813637,1023161,503596,647537,449833,1014229,786740,482450,620434,705362,522153,208273,894885,654763,906524,758054,844532,383894,939512,798698,277613,460459,938992,710725,1042550,664614,903446,310776,481569,460871,179229,799013,920527,341192,564961,921220,609015,567103,79262,220382,220524,661869,936563,109063,878377,871295,482196,992908,852885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001182s ]