SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802794 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802794 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013610,829625,539004,986264,858295,194780,309579,281643,136129,882776,110693,981616,540691,483163,430047,328686,1047294,369875,579012,710382,110327,291380,546203,552207,147662,93526,312042,860015,3466,682053,707632,645106,471010,380218,551074,1045711,881803,239836,287683,490473,989951,748453,768161,180625,55445,772997,534874,780014,810384,783437,969428,47312,980354,994174,912579,517447,748867,672273,622067,699650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]