SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409666 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409666 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836883,211058,563216,899880,571668,366499,608392,877464,923836,253928,411288,442499,460242,710397,702254,1047742,10408,1009799,760652,581547,951381,647353,291681,1027063,77908,757351,104988,900126,338183,63076,616715,1002656,665436,263258,931886,901142,414416,729777,734155,595223,280412,950074,145767,830373,64186,150409,438819,26609,183457,408584,973542,1030127,172430,381781,535905,538008,422485,374809,519788,443009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409666 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409666 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]