SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501444 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501444 [ RunTime:0.003784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722054,474215,1017890,626186,1007625,361200,527464,982134,182889,283744,434122,10449,971673,365294,924792,615518,753690,150776,952169,35094,531346,94463,50112,455727,944483,748746,524993,354292,1019304,354381,421542,47718,693832,655001,756661,658001,595379,813037,919255,123732,786385,187591,679442,742940,247502,904353,354739,754152,254569,491898,247314,457800,900802,537057,695236,83553,579869,496137,434112,322872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501444 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501444 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]