SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 165107 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 165107 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470041,223694,331924,836064,423001,376414,134861,392453,602576,639665,889674,496311,617285,540976,700071,53246,804287,654937,728047,967308,1020650,420857,951609,311051,21300,273704,746468,811042,829116,804203,729617,792614,70740,211366,935120,789424,409371,331314,684968,415407,848340,914235,1015460,556087,465158,331920,490334,571498,699300,452017,178715,78854,213105,825490,697185,733353,308645,367013,855664,932111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 165107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 165107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]