SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416787 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416787 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11639,265053,297119,347540,290662,199861,215591,218573,11680,969238,616410,522894,904275,376241,190374,245142,192811,380501,507389,653017,829419,814972,444977,472947,846999,971179,70955,277528,60435,70347,46974,716345,519301,259469,872551,456835,390804,925222,589261,833151,116319,483649,1024756,527923,133730,229037,526063,1006944,681194,635118,573057,805121,1029121,26925,953831,325745,1026841,163895,485579,91956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]