SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806041 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806041 [ RunTime:0.003424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544002,33962,707990,491568,730658,834284,374994,955568,278019,117578,39151,227836,647241,413498,802573,806261,553632,265302,533023,12923,81487,176393,259311,268586,298670,421031,769457,50355,551259,240320,304787,634411,745178,87828,800405,425807,926297,604929,414289,686690,393498,470923,904209,1026358,234724,148146,569089,508725,595352,1045359,947572,398884,368561,1039046,765151,717005,946961,883503,806894,832255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]