SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480251 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480251 [ RunTime:0.003340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011573,334145,897477,594451,87612,484144,1029147,457303,749979,1006961,326329,393814,829571,483074,849941,335964,222855,568784,1712,540617,818623,302070,546175,421504,140794,407987,1008011,662027,324550,192798,743786,975099,935449,349310,330168,17756,988108,984878,331103,834392,198171,211772,986725,76651,965345,796739,519497,602935,843222,1002898,460208,1024675,12802,342718,817653,902801,708342,232099,423050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]