SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36147 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36147 [ RunTime:0.002433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322131,475103,52688,235447,744863,821775,1008953,284006,126547,190203,266354,395087,1006899,426585,509780,640048,759683,287443,609619,831865,876929,581656,488040,1031260,645809,648089,271606,127587,712516,905924,237273,143745,295818,149270,896229,396450,868109,544279,179964,962391,251315,990442,35635,24102,254271,564754,766358,591302,628534,756481,201765,150926,1024413,78593,867733,334636,340898,975562,110740,400213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]