SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 951498 LIMIT 1 [ RunTime:0.001463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 951498 [ RunTime:0.004149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127421,431826,621589,1031228,822254,24356,319480,456056,251182,340778,567339,614743,288764,847552,115043,686732,801678,51131,675151,866470,122337,901114,99343,851120,765292,252396,196555,315359,998063,61918,648000,237585,450316,240732,24108,322833,223813,488228,501764,544881,1024828,231614,750471,626266,301281,75034,565472,54049,591442,115501,845506,238017,818783,31017,799135,76415,115107,327142,252695,624522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 951498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 951498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]