SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020125 LIMIT 1 [ RunTime:0.007194s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020125 [ RunTime:0.003354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786827,581874,1021676,1007837,956621,825978,722018,750713,327192,594048,593514,127960,1013760,229409,169799,566030,492411,1025995,84149,823421,123138,645642,274454,229678,19432,185767,724130,718006,284949,282946,639684,864296,979112,333277,304806,72031,27602,683951,390517,504118,976236,175071,567038,826299,120072,262057,704431,362253,78187,977435,1025828,230908,742439,974715,395658,1011678,370895,959595,99667,532180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020125 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020125 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]