SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41052 LIMIT 1 [ RunTime:0.004852s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41052 [ RunTime:0.006748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363066,309897,18282,494679,747662,1035595,762345,946781,659249,843583,994687,53267,984002,844805,803212,26222,860846,48505,622051,759976,161001,600356,584515,748134,430324,370599,579062,668118,190973,685589,112884,786352,906848,396210,421268,116156,59461,179394,989552,316761,301241,48090,857547,930794,737361,702742,30126,517654,727110,735349,998432,918768,14454,484205,768152,83664,331336,573427,1018560,711190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]