SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014475 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014475 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607965,849760,258854,983213,675239,423862,1029901,917391,696558,501934,960492,309587,347491,741649,570266,597587,807471,635558,77599,923145,596032,101281,519781,709364,878194,911967,722327,654957,499153,604563,765038,94096,616901,919584,1029656,299363,659910,827617,611277,147183,736294,648316,562088,269333,657002,945105,852456,231098,647222,847817,1004271,407342,535798,433224,616499,904895,581506,26750,248409,1008621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]