SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340081 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340081 [ RunTime:0.003334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879876,63995,542780,278210,71692,168977,882671,357395,493622,719600,518930,451291,1041151,556621,670703,245270,829392,749815,281282,386270,249447,994024,54243,929409,60379,160370,599066,902706,184492,67883,175513,713626,455863,470943,567768,711354,447438,581532,255654,369,298525,477942,918925,719185,354627,634846,379062,866610,519257,798971,118528,1036589,497945,353861,369174,469716,921960,608586,992117,905248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]