SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300311 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300311 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749419,444642,819103,872249,176386,197874,136511,171909,287930,630510,977734,697470,362142,1004297,536471,11437,1037515,65237,164061,663469,485658,225138,1000476,851764,540764,992365,818855,871761,615205,144545,712402,95876,285511,678961,64126,958983,541020,852333,792238,759435,512746,300707,289808,520295,237467,113449,207260,918401,61552,250215,615903,846970,1017403,125309,462729,428110,234774,210785,328454,904264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]