SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164683 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164683 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499180,830411,104299,617539,560443,341508,316523,719477,761906,151632,971796,937523,20651,719739,493310,417801,940111,1042152,536661,221470,861561,46034,755283,161678,285853,230944,274725,748809,344844,508767,394832,359800,893441,719030,227220,751361,714539,621519,866057,518896,135150,946770,213598,812358,22935,850895,636698,372629,576040,732744,243875,704173,323027,551297,981319,951329,778399,218370,10109,427859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]