SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342875 LIMIT 1 [ RunTime:0.001250s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342875 [ RunTime:0.002520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640871,704439,471117,33428,3805,49493,373799,102740,559147,769077,486237,779790,826143,968992,394567,1004570,688582,322217,66393,1014207,721851,841090,779744,751157,859170,996772,554631,891725,176961,695149,905107,216777,997699,436197,950799,489610,264788,351535,1000841,622963,264562,23335,557332,534219,243071,603515,481580,244250,794998,101677,429224,48759,455625,990757,225157,913145,518072,188840,56921,396657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]