SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036821 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036821 [ RunTime:0.002880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153313,262514,162621,582410,419301,740656,642547,841945,767826,498513,900787,101919,443586,582289,870978,57208,871285,407036,624025,1022856,290268,324447,668706,946851,279840,524042,821066,673399,904511,1043514,904396,435659,953952,781232,961018,384622,469088,531982,964664,593869,780948,468110,765082,54191,617138,477237,506375,1015768,936853,713099,1010966,294636,529133,748547,474375,381095,703984,542262,467550,36686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]