SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002999s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481803 LIMIT 1 [ RunTime:0.003874s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481803 [ RunTime:0.002995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745665,246694,952102,199439,618731,311350,518454,898106,836278,407337,468113,207172,656668,809649,858156,1008046,714727,33882,210276,236458,584854,438406,1016219,367122,1401,58192,723581,928707,188564,375227,143156,258390,907147,373872,882403,627469,638486,622997,415254,644712,378282,888575,345857,661489,475780,908027,327195,100351,89851,35826,763752,234740,190307,712506,151958,4220,401000,213097,1033057,623270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]