SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51306 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51306 [ RunTime:0.004199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181806,860159,411836,397770,896687,670009,527682,328668,272692,972447,32632,347419,372768,839922,14400,424341,518645,981218,601703,153546,765362,579255,419408,615548,533671,486147,561347,214148,3997,110026,115948,742396,626300,494929,103168,619273,600169,1041569,904768,537335,249942,320540,147959,1016240,712439,253183,118832,334451,93951,831247,1006889,673817,654565,237901,855503,3501,806663,73276,459092,289952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]