SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 375511 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 375511 [ RunTime:0.002127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138741,554503,384233,353815,746022,634780,584575,362404,127968,195808,387899,617838,556064,218887,905287,916446,650309,859806,148142,200410,920647,635368,119928,10664,361381,62044,145985,185185,164544,430744,496705,835157,261736,316637,262694,456937,911470,80604,437415,457823,698163,250087,597685,426979,79569,461360,1048682,857417,288458,502523,198977,480830,235079,976709,411606,64762,717650,158191,928666,822731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 375511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 375511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]