SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520409 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520409 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534669,911923,358631,775370,447305,323362,291777,386748,941383,648210,28086,1026993,655924,825431,807475,664866,827339,465249,867077,122358,46860,401157,862696,87434,613452,739887,1031947,330284,977068,160151,520375,214083,10898,519595,862587,223173,388846,776429,587591,452560,97733,631268,600588,833917,834418,346791,395541,948314,433963,18502,672374,788989,502635,661001,25561,738621,788074,722966,17626,75084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003489s ]