SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434798 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434798 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803617,107768,739255,442522,292816,41029,1045901,46848,54181,667778,632351,376377,868806,303686,141808,506337,851323,687226,180090,955985,832217,598192,753406,409205,635619,500375,524832,865520,470944,711539,309028,104765,114389,479949,715632,860321,144983,159531,75287,230123,103649,183878,1024914,139267,558850,881217,766797,1022333,840771,128314,303049,335559,513881,601975,11874,150873,187633,201079,971282,609186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]