SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80413 LIMIT 1 [ RunTime:0.003341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80413 [ RunTime:0.008171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562868,561691,835290,146377,757197,604848,695438,489306,402736,670052,240306,415556,4356,857971,307375,308018,442776,41452,1010089,978128,502746,867187,215337,746276,877761,949626,1034204,45690,998822,749452,1044803,488825,698052,244877,634015,50114,795658,946200,872804,441316,598708,567329,460182,839651,600563,285468,165406,319769,152123,675433,200074,41532,122058,590596,559484,475908,319177,695868,921599,20005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]