SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020219 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020219 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485376,836869,658955,362490,671905,687647,568828,875651,405790,564253,502958,433618,760680,105667,707128,255332,971345,372124,602156,325049,456636,775894,872073,921479,843851,370124,39861,291918,1004441,90213,1012527,538306,153787,920444,385820,591949,1020275,664495,593078,539434,1041772,1017088,458377,164263,1001721,599159,113657,940246,946259,496288,870790,783230,669431,1003260,418001,997665,437019,995167,838132,455716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]