SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551099 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551099 [ RunTime:0.002105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51676,84525,729025,600661,387179,844748,671791,861420,832105,550436,226842,939591,423626,457562,859647,785749,612557,1002921,280577,737326,767079,787401,591332,86142,72204,332556,129993,388955,756177,704514,823314,343649,342221,982527,254318,160226,925105,325246,348210,807313,148122,393670,1040440,668282,795087,707235,1001288,935352,96566,41563,46971,477674,181751,869408,1026915,205768,766546,244305,698826,906699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]