SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009210 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009210 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19458,485811,505085,169729,287020,398570,326316,853711,317158,526584,579357,937801,626432,82483,243405,201857,606877,12283,311228,574479,224333,871507,451561,797246,610983,97057,1010993,909891,393629,325509,740225,312558,602879,382554,800071,458289,602814,639886,432517,563369,623452,900401,708749,107925,969693,568358,186686,898262,296442,209526,894329,933157,21083,436515,1015619,978087,731100,622151,112411,946696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]