SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98044 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98044 [ RunTime:0.003169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677490,985280,445973,384860,9497,711115,548043,242407,267496,540079,900980,421460,496434,366565,694566,195428,597610,795648,133000,808450,199204,482307,55977,903890,507786,382148,672794,429116,120515,637275,659245,124375,483333,356754,602367,85135,566656,1020770,697440,204351,306177,99465,605009,230799,468206,161127,259164,474444,10938,875015,1008221,713558,730816,288691,443246,348638,848858,1015154,77007,786403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]