SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039280 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039280 [ RunTime:0.005247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793498,748281,789759,971606,180109,627366,261055,54302,198624,450881,137187,628235,721565,92309,255383,186643,526513,237010,348515,701816,501170,771532,48681,1039390,740042,378951,675495,459555,211552,803181,550836,962017,504480,497089,751324,517426,684974,675428,395374,835337,173533,1027351,108765,616718,904130,712145,983359,79232,788360,11458,952637,301038,650916,154031,344616,551499,833224,189234,86017,575686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000787s ]