SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283920 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283920 [ RunTime:0.002863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174741,1043847,831152,1039941,159671,44044,262690,844156,608490,269657,447174,657410,868974,885711,504958,12942,882940,448829,1015114,72287,252063,353211,1032659,482886,139476,351067,474631,448677,635764,548695,368694,292236,258157,690208,960168,439332,972951,596588,975947,722585,385264,552801,1009919,1032251,31537,463184,1011752,342120,524076,457268,839346,502284,813665,106733,329830,429191,106148,523676,370646,10194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283920 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283920 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000853s ]