SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421428 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421428 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674291,788997,130007,805538,896127,354810,343583,692211,165948,181088,22742,795638,741902,692267,373211,658044,479145,417566,372722,115676,334854,145739,635051,311414,109491,711709,317575,704728,140732,236609,899334,650292,741266,721388,568243,817427,797105,24829,320310,890670,685186,923178,608406,443559,319841,375935,1015249,658378,378189,123982,550939,541248,895930,15421,794912,554878,304321,1010117,744874,570203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]