SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50812 LIMIT 1 [ RunTime:0.002168s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50812 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647998,686051,6488,11774,623039,529151,364050,120484,1000534,573041,764738,230565,33301,898765,388774,306928,1039802,155736,299049,951596,882441,879074,976476,546830,323931,71880,558772,597669,91099,367601,166933,585736,858944,452256,258603,622347,991864,705537,1021586,838969,560493,280770,452526,124708,656271,595969,1010920,967521,916553,873522,395419,364764,685450,401161,791062,183303,930860,1040885,755504,973740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]