SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416615 LIMIT 1 [ RunTime:0.002166s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416615 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006311,457325,891017,567042,966965,664649,712637,640933,1001920,599219,234317,209872,599139,183894,1021921,60224,835610,872315,194443,534546,751310,193827,548218,593829,589187,595913,832797,125018,834830,429966,898063,544036,201212,836089,61723,30082,1002583,72659,535901,929935,102801,48127,750789,478669,301454,676094,1029029,739411,676005,841234,177079,240324,12236,376252,624494,507696,602715,330025,576897,436252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]