SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467941 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467941 [ RunTime:0.001390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663305,850148,375530,423883,526528,561510,659693,85809,815944,83298,51367,845168,850494,59723,694044,300230,384165,550830,113539,117380,252407,5672,761314,492067,545176,434968,538349,206014,263148,809375,363091,723971,720026,866919,172540,633169,743945,344155,203732,282480,163091,572027,697294,741103,339432,171113,718641,907853,565815,337919,410553,642614,964912,826292,162306,148808,776623,796749,865694,66037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000375s ]