SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200309 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200309 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615867,129060,639627,852487,863363,488880,322606,558302,1009442,596726,743880,677467,233650,595150,913409,175274,594154,587106,156761,57677,258794,254819,599544,881298,121792,437604,227987,95408,391018,578487,886650,937889,910562,1038917,164106,913881,503229,385905,873528,758939,400532,482432,714790,17950,679555,944473,491379,487448,786299,478079,285130,598234,255891,175013,792685,501969,79304,498535,84644,591709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]