SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017242 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017242 [ RunTime:0.002611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268114,806167,899130,183609,7958,725776,465549,200094,72449,441538,706321,92755,124274,734813,82503,1001863,829324,636303,1020482,280550,353129,583026,828499,782946,364951,633201,432565,230086,698684,744962,203326,253817,735369,768277,510184,225210,944231,128001,843424,630157,691102,204835,1048821,221611,238183,943427,611607,971395,228647,904108,956745,316445,765418,222308,919848,942716,483596,409956,262773,75343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017242 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017242 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]