SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 730213 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 730213 [ RunTime:0.002789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675610,805027,772279,264609,1006140,129634,267640,429228,837212,771448,526559,977065,919453,1034029,899265,826863,662734,528210,279736,662298,7644,494799,4059,338915,998992,370009,842300,855133,945974,43506,416034,134625,342405,354844,928420,847254,182491,735299,367121,271366,703546,451749,662275,311520,971216,835494,249448,3564,648080,815469,4545,977780,469258,996777,969327,557543,188245,503321,466468,779891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 730213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 730213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]