SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291907 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291907 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45351,1034945,808052,22332,398683,806863,572251,748828,540289,1018742,865912,538411,334815,1025811,684769,213721,837766,397387,518914,926524,594896,196083,841404,967393,714756,305674,632645,139988,985889,957474,179587,444484,506500,970701,173470,275050,283538,739275,147532,652904,611257,310486,359784,142973,260822,662980,348163,177629,901997,82262,126185,1047652,525803,163806,439105,604479,102251,257754,876852,992493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]