SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489812 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489812 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120383,888471,576696,482285,461029,959476,955906,487825,47678,693157,88003,634071,1021736,889396,1022485,287277,308409,706852,672199,462879,94649,943972,430004,799852,681181,606322,600755,87839,561975,147656,214147,679828,429652,394928,485746,1012106,213327,551402,721016,688993,356243,570488,65363,275926,1028786,91913,281419,45605,1042813,608716,552428,919599,577303,78011,478574,159396,1001223,215421,424564,933785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]