SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045200 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045200 [ RunTime:0.002712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850752,727489,609381,528004,790449,487117,638502,224918,671001,845306,462788,106703,327894,821349,857268,662102,371194,700115,237647,6089,736845,994763,659973,824946,584715,40666,116375,332215,285462,538407,746376,261344,75627,850015,706324,729443,415624,174813,372371,306825,547749,468066,481380,666200,830379,355030,561086,4250,656206,492535,669412,303775,449538,908648,777190,647136,396712,990650,846882,624824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]