SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 828013 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 828013 [ RunTime:0.003299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98627,640108,109024,718270,146413,778831,656009,334797,46181,136893,1031157,526128,206306,1032613,365403,385869,451286,525813,50668,949071,23461,1029353,62460,661677,87535,54057,758586,96467,366109,1046466,310010,535163,367346,346374,203481,527032,795700,96769,632155,127957,735818,519311,20405,622859,237381,869672,691992,766100,153751,1040135,482637,247890,348676,316064,1323,520711,742101,840519,486187,708086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 828013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 828013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001723s ]