SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586853 LIMIT 1 [ RunTime:0.000669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586853 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570171,546946,720122,496971,609286,269383,444230,655020,47238,1043339,811277,860885,327816,581333,562398,736761,460235,914567,541073,271038,384374,697900,773112,973894,726228,343957,939759,704271,665262,956898,712067,842146,662474,1016542,911184,79695,227807,243134,47218,651402,679373,250499,759591,596250,999693,868032,12095,556523,700694,612317,380272,82521,882503,378204,185401,312697,296119,767123,947493,268178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]