SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 869253 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 869253 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012205,440628,493801,579124,615174,993257,1004792,744396,867493,412365,253849,520371,861738,817246,508833,1004554,603376,733944,886475,187894,909072,192860,117834,404497,747152,971890,913909,989407,80203,30504,100446,409454,885991,290772,689702,497089,437595,391237,635285,495162,630581,881306,401901,120858,333052,786559,590549,95069,462940,382943,44992,799667,354224,497379,213934,526920,1411,808619,788911,385246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 869253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 869253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]