SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424842 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424842 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994961,20095,233645,640106,198498,806880,645900,835334,30954,915969,1010790,13282,876548,186108,733591,844826,580718,287388,37965,849493,504811,1001561,914262,942330,119892,459635,811335,470592,791066,390321,838774,447278,561262,805499,394091,951954,245665,988407,330232,967848,1010826,530324,482379,42435,84687,841041,258802,398763,265736,988397,215067,294914,298624,255768,786433,629939,111007,891449,490794,403488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]