SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601828 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601828 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40128,529212,831597,973885,853257,606035,926776,412840,206705,322464,1042669,1018026,541942,948690,582391,539569,186101,608842,562116,697027,346994,907310,473693,294812,724957,727461,998661,244979,169953,155505,156130,490438,423335,260015,798113,495481,393661,368691,731415,212748,428059,1041344,702600,213718,159110,127965,374254,587752,795695,187920,429015,842249,684831,565664,64106,514637,349036,216447,171939,296197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]